SortBy(IWorksheet,Reference,Int32[],SortOn[],Object[],SortOrder[]) Method
In This Topic
Sort the range using multiple conditions.
Syntax
'Declaration
Public Overloads Shared Function SortBy( _
ByVal As IWorksheet, _
ByVal As Reference, _
ByVal columnIndexes() As Integer, _
ByVal () As SortOn, _
ByVal () As Object, _
ByVal () As SortOrder _
) As SortCommand
'Usage
Dim worksheet As IWorksheet
Dim range As Reference
Dim columnIndexes() As Integer
Dim sortOns() As SortOn
Dim sortValues() As Object
Dim sortOrders() As SortOrder
Dim value As SortCommand
value = SortCommand.SortBy(worksheet, range, columnIndexes, sortOns, sortValues, sortOrders)
Parameters
- worksheet
- The worksheet to sort.
- range
- The sorting range.
- columnIndexes
- The indexes of sorting columns.
- sortOns
- A GrapeCity.Spreadsheet.SortOn array that indicates which data will be sorted.
- sortValues
- An array that indicates sorting values.
- sortOrders
- A GrapeCity.Spreadsheet.SortOrder array that indicates the sorting order.
See Also